import matplotlib.pyplot as plt
import pandas as pd
df = pd.read_excel('学生各学期成绩表.xlsx')
plt.figure(figsize=(12, 8))
x = df['序号']
plt.subplot(2, 2, 1)
plt.plot(x, df['语文'])
plt.subplot(2, 2, 2)
plt.plot(x, df['数学'])
plt.subplot(2, 2, 3)
plt.plot(x, df['英语'])
plt.subplot(2, 2, 4)
plt.plot(x, df['综合'])
plt.show()
